﻿USE [WebGZPAG]
GO
/****** Object:  Table [dbo].[Web_Base_Account_Biz]    Script Date: 2015/6/6 14:56:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Web_Base_Account_Biz](
	[PkId] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[ParentId] [int] NULL,
	[SortId] [int] NULL,
	[Name] [nvarchar](max) NULL,
	[Pass] [nvarchar](max) NULL,
	[Content] [nvarchar](max) NULL,
	[Memo] [nvarchar](max) NULL,
	[FlagClick] [int] NULL,
	[FlagClickView] [int] NULL,
	[FlagStatus] [int] NULL,
	[id] [int] NULL,
	[count] [int] NULL,
	[level] [int] NULL,
	[score] [int] NULL,
	[status] [int] NULL,
	[total] [int] NULL,
	[attributes] [nvarchar](max) NULL,
	[children] [nvarchar](max) NULL,
	[info] [nvarchar](max) NULL,
	[json] [nvarchar](max) NULL,
	[msg] [nvarchar](max) NULL,
	[rows] [nvarchar](max) NULL,
	[state] [nvarchar](max) NULL,
	[temp] [nvarchar](max) NULL,
	[text] [nvarchar](max) NULL,
 CONSTRAINT [PK_Web_Base_Account_Biz] PRIMARY KEY CLUSTERED 
(
	[PkId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Web_Base_Account_Member]    Script Date: 2015/6/6 14:56:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Web_Base_Account_Member](
	[PkId] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[ParentId] [int] NULL,
	[SortId] [int] NULL,
	[Name] [nvarchar](max) NULL,
	[Pass] [nvarchar](max) NULL,
	[Content] [nvarchar](max) NULL,
	[Memo] [nvarchar](max) NULL,
	[FlagClick] [int] NULL,
	[FlagClickView] [int] NULL,
	[FlagStatus] [int] NULL,
	[id] [int] NULL,
	[count] [int] NULL,
	[level] [int] NULL,
	[score] [int] NULL,
	[status] [int] NULL,
	[total] [int] NULL,
	[attributes] [nvarchar](max) NULL,
	[children] [nvarchar](max) NULL,
	[info] [nvarchar](max) NULL,
	[json] [nvarchar](max) NULL,
	[msg] [nvarchar](max) NULL,
	[rows] [nvarchar](max) NULL,
	[state] [nvarchar](max) NULL,
	[temp] [nvarchar](max) NULL,
	[text] [nvarchar](max) NULL,
 CONSTRAINT [PK_Web_Base_Account_Member] PRIMARY KEY CLUSTERED 
(
	[PkId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Web_Base_Account_Staff]    Script Date: 2015/6/6 14:56:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Web_Base_Account_Staff](
	[PkId] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[ParentId] [int] NULL,
	[SortId] [int] NULL,
	[Name] [nvarchar](max) NULL,
	[Pass] [nvarchar](max) NULL,
	[Content] [nvarchar](max) NULL,
	[Memo] [nvarchar](max) NULL,
	[FlagClick] [int] NULL,
	[FlagClickView] [int] NULL,
	[FlagStatus] [int] NULL,
	[id] [int] NULL,
	[count] [int] NULL,
	[level] [int] NULL,
	[score] [int] NULL,
	[status] [int] NULL,
	[total] [int] NULL,
	[attributes] [nvarchar](max) NULL,
	[children] [nvarchar](max) NULL,
	[info] [nvarchar](max) NULL,
	[json] [nvarchar](max) NULL,
	[msg] [nvarchar](max) NULL,
	[rows] [nvarchar](max) NULL,
	[state] [nvarchar](max) NULL,
	[temp] [nvarchar](max) NULL,
	[text] [nvarchar](max) NULL,
 CONSTRAINT [PK_Web_Base_Account_Staff] PRIMARY KEY CLUSTERED 
(
	[PkId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Web_Base_Account_Super]    Script Date: 2015/6/6 14:56:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Web_Base_Account_Super](
	[PkId] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[ParentId] [int] NULL,
	[SortId] [int] NULL,
	[Name] [nvarchar](max) NULL,
	[Pass] [nvarchar](max) NULL,
	[Content] [nvarchar](max) NULL,
	[Memo] [nvarchar](max) NULL,
	[FlagClick] [int] NULL,
	[FlagClickView] [int] NULL,
	[FlagStatus] [int] NULL,
	[id] [int] NULL,
	[count] [int] NULL,
	[level] [int] NULL,
	[score] [int] NULL,
	[status] [int] NULL,
	[total] [int] NULL,
	[attributes] [nvarchar](max) NULL,
	[children] [nvarchar](max) NULL,
	[info] [nvarchar](max) NULL,
	[json] [nvarchar](max) NULL,
	[msg] [nvarchar](max) NULL,
	[rows] [nvarchar](max) NULL,
	[state] [nvarchar](max) NULL,
	[temp] [nvarchar](max) NULL,
	[text] [nvarchar](max) NULL,
 CONSTRAINT [PK_Web_Base_Account_Super] PRIMARY KEY CLUSTERED 
(
	[PkId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Web_Base_Account_User]    Script Date: 2015/6/6 14:56:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Web_Base_Account_User](
	[PkId] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[ParentId] [int] NULL,
	[SortId] [int] NULL,
	[Name] [nvarchar](max) NULL,
	[Pass] [nvarchar](max) NULL,
	[Content] [nvarchar](max) NULL,
	[Memo] [nvarchar](max) NULL,
	[FlagClick] [int] NULL,
	[FlagClickView] [int] NULL,
	[FlagStatus] [int] NULL,
	[id] [int] NULL,
	[count] [int] NULL,
	[level] [int] NULL,
	[score] [int] NULL,
	[status] [int] NULL,
	[total] [int] NULL,
	[attributes] [nvarchar](max) NULL,
	[children] [nvarchar](max) NULL,
	[info] [nvarchar](max) NULL,
	[json] [nvarchar](max) NULL,
	[msg] [nvarchar](max) NULL,
	[rows] [nvarchar](max) NULL,
	[state] [nvarchar](max) NULL,
	[temp] [nvarchar](max) NULL,
	[text] [nvarchar](max) NULL,
 CONSTRAINT [PK_Web_Base_Account_User] PRIMARY KEY CLUSTERED 
(
	[PkId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Web_Base_Account_Vip]    Script Date: 2015/6/6 14:56:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Web_Base_Account_Vip](
	[PkId] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[ParentId] [int] NULL,
	[SortId] [int] NULL,
	[Name] [nvarchar](max) NULL,
	[Pass] [nvarchar](max) NULL,
	[Content] [nvarchar](max) NULL,
	[Memo] [nvarchar](max) NULL,
	[FlagClick] [int] NULL,
	[FlagClickView] [int] NULL,
	[FlagStatus] [int] NULL,
	[id] [int] NULL,
	[count] [int] NULL,
	[level] [int] NULL,
	[score] [int] NULL,
	[status] [int] NULL,
	[total] [int] NULL,
	[attributes] [nvarchar](max) NULL,
	[children] [nvarchar](max) NULL,
	[info] [nvarchar](max) NULL,
	[json] [nvarchar](max) NULL,
	[msg] [nvarchar](max) NULL,
	[rows] [nvarchar](max) NULL,
	[state] [nvarchar](max) NULL,
	[temp] [nvarchar](max) NULL,
	[text] [nvarchar](max) NULL,
 CONSTRAINT [PK_Web_Base_Account_Vip] PRIMARY KEY CLUSTERED 
(
	[PkId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Web_Base_Accounts_Ext_Base]    Script Date: 2015/6/6 14:56:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Web_Base_Accounts_Ext_Base](
	[PkId] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[AccId] [int] NOT NULL,
	[AccIdType] [int] NOT NULL,
	[NameTrue] [nvarchar](max) NULL,
	[NameFull] [nvarchar](max) NULL,
	[NameAs] [nvarchar](max) NULL,
	[Sex] [int] NULL,
	[Birth] [date] NULL,
	[Mobile] [nvarchar](max) NULL,
	[Mail] [nvarchar](max) NULL,
	[QQ] [nvarchar](max) NULL,
	[Memo] [nvarchar](max) NULL,
	[Message] [nvarchar](max) NULL,
	[FundPostFDT] [datetime] NULL,
	[FundPostLDT] [datetime] NULL,
	[flagActive] [int] NULL,
	[flagType] [int] NULL,
	[flagLevel] [int] NULL,
	[flagStatus] [int] NULL,
 CONSTRAINT [PK_Web_Base_Accounts_Ext_Base] PRIMARY KEY CLUSTERED 
(
	[PkId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Web_Base_Accounts_Log_Action]    Script Date: 2015/6/6 14:56:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Web_Base_Accounts_Log_Action](
	[PkId] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[AccId] [int] NOT NULL,
	[AccIdType] [int] NOT NULL,
	[FromId] [int] NOT NULL,
	[FromType] [int] NOT NULL,
	[Memo] [nvarchar](max) NULL,
	[CreateDateTimes] [datetime] NULL,
	[flagStatus] [int] NULL,
 CONSTRAINT [PK_Web_Base_Accounts_Log_Action] PRIMARY KEY CLUSTERED 
(
	[PkId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Web_Base_Accounts_Log_Admin]    Script Date: 2015/6/6 14:56:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Web_Base_Accounts_Log_Admin](
	[PkId] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[AccId] [int] NOT NULL,
	[AccIdType] [int] NOT NULL,
	[FromId] [int] NOT NULL,
	[FromIdType] [int] NOT NULL,
	[Memo] [nvarchar](max) NULL,
	[CreateDateTimes] [datetime] NULL,
	[flagStatus] [int] NULL,
 CONSTRAINT [PK_Web_Base_Accounts_Log_Admin] PRIMARY KEY CLUSTERED 
(
	[PkId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Web_Base_Accounts_Log_Message]    Script Date: 2015/6/6 14:56:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Web_Base_Accounts_Log_Message](
	[PkId] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[AccId] [int] NOT NULL,
	[AccIdType] [int] NOT NULL,
	[FromId] [int] NOT NULL,
	[FromIdType] [int] NOT NULL,
	[Title] [nvarchar](max) NULL,
	[Content] [nvarchar](max) NULL,
	[CreateIP] [nvarchar](max) NULL,
	[CreateDateTimes] [datetime] NULL,
	[flagStatus] [int] NULL,
 CONSTRAINT [PK_Web_Base_Accounts_Log_Message] PRIMARY KEY CLUSTERED 
(
	[PkId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Web_Base_Accounts_Log_Visitor]    Script Date: 2015/6/6 14:56:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Web_Base_Accounts_Log_Visitor](
	[PkId] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[AccId] [int] NOT NULL,
	[AccIdType] [int] NOT NULL,
	[FromId] [int] NOT NULL,
	[FromIdType] [int] NOT NULL,
	[CreateDateTimes] [datetime] NULL,
	[CreateIP] [nvarchar](max) NULL,
	[Url] [nvarchar](max) NULL,
	[Memo] [nvarchar](max) NULL,
	[flagStatus] [int] NULL,
 CONSTRAINT [PK_Web_Base_Accounts_Log_Visitor] PRIMARY KEY CLUSTERED 
(
	[PkId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Web_Base_Config_Global]    Script Date: 2015/6/6 14:56:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Web_Base_Config_Global](
	[PkId] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[SiteId] [int] NULL,
	[TemplateHome] [nvarchar](max) NULL,
	[TemplateIndex] [nvarchar](max) NULL,
	[TemplateNode] [nvarchar](max) NULL,
	[TemplateList] [nvarchar](max) NULL,
	[TemplateView] [nvarchar](max) NULL,
	[TemplateSeek] [nvarchar](max) NULL,
	[TemplateTop] [nvarchar](max) NULL,
	[flagStatus] [int] NULL,
 CONSTRAINT [PK_Web_Base_Config_Global] PRIMARY KEY CLUSTERED 
(
	[PkId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Web_Base_Config_Site_Info]    Script Date: 2015/6/6 14:56:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Web_Base_Config_Site_Info](
	[PkId] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[SortId] [int] NULL,
	[ParentId] [int] NULL,
	[NodeId] [int] NULL,
	[Title] [nvarchar](max) NULL,
	[Content] [nvarchar](max) NULL,
	[Icon] [nvarchar](max) NULL,
	[Logo] [nvarchar](max) NULL,
	[Tag] [nvarchar](max) NULL,
	[Keyword] [nvarchar](max) NULL,
	[Description] [nvarchar](max) NULL,
	[FlagView] [int] NULL,
	[FlagPass] [int] NULL,
	[FlagStop] [int] NULL,
	[FlagStatus] [int] NULL,
	[TemplateHome] [nvarchar](max) NULL,
	[TemplateIndex] [nvarchar](max) NULL,
	[TemplateNode] [nvarchar](max) NULL,
	[TemplateList] [nvarchar](max) NULL,
	[TemplateView] [nvarchar](max) NULL,
	[TemplateSeek] [nvarchar](max) NULL,
	[TemplateTop] [nvarchar](max) NULL,
 CONSTRAINT [PK_Web_Base_Config_Site_Info] PRIMARY KEY CLUSTERED 
(
	[PkId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Web_Base_Config_Site_Node]    Script Date: 2015/6/6 14:56:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Web_Base_Config_Site_Node](
	[PkId] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[SortId] [int] NULL,
	[ParentId] [int] NULL,
	[NodeId] [int] NULL,
	[Title] [nvarchar](max) NULL,
	[Content] [nvarchar](max) NULL,
	[Icon] [nvarchar](max) NULL,
	[Logo] [nvarchar](max) NULL,
	[Tag] [nvarchar](max) NULL,
	[Keyword] [nvarchar](max) NULL,
	[Description] [nvarchar](max) NULL,
	[FlagView] [int] NULL,
	[FlagPass] [int] NULL,
	[FlagStop] [int] NULL,
	[FlagStatus] [int] NULL,
 CONSTRAINT [PK_Web_Base_Config_Site_Node] PRIMARY KEY CLUSTERED 
(
	[PkId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Web_Base_Exts_Field]    Script Date: 2015/6/6 14:56:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Web_Base_Exts_Field](
	[PkId] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[NodeId] [int] NULL,
	[ValueInt1] [int] NULL,
	[ValueInt2] [int] NULL,
	[ValueInt3] [int] NULL,
	[ValueFloat1] [float] NULL,
	[ValueFloat2] [float] NULL,
	[ValueFloat3] [float] NULL,
	[ValueString1] [nvarchar](max) NULL,
	[ValueString2] [nvarchar](max) NULL,
	[ValueString3] [nvarchar](max) NULL,
	[ValueString4] [nvarchar](max) NULL,
	[ValueString5] [nvarchar](max) NULL,
	[ValueString6] [nvarchar](max) NULL,
	[ValueDateTime1] [datetime] NULL,
	[ValueDateTime2] [datetime] NULL,
	[ValueDateTime3] [datetime] NULL,
 CONSTRAINT [PK_Web_Base_Exts_Field] PRIMARY KEY CLUSTERED 
(
	[PkId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Web_Base_Exts_Log]    Script Date: 2015/6/6 14:56:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Web_Base_Exts_Log](
	[PkId] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[Type] [int] NULL,
	[NodeId] [int] NULL,
	[InfoId] [int] NULL,
	[AccId] [int] NULL,
	[AccIdType] [int] NULL,
	[Memo] [nvarchar](max) NULL,
 CONSTRAINT [PK_Web_Base_Exts_Log] PRIMARY KEY CLUSTERED 
(
	[PkId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Web_Base_Exts_Meta]    Script Date: 2015/6/6 14:56:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Web_Base_Exts_Meta](
	[PkId] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[Type] [int] NULL,
	[NodeId] [int] NULL,
	[InfoId] [int] NULL,
	[Application-name] [nchar](10) NULL,
	[Author] [nchar](10) NULL,
	[Copyright] [nchar](10) NULL,
	[Description] [nchar](10) NULL,
	[Generator] [nchar](10) NULL,
	[Keywords] [nchar](10) NULL,
	[Msapplication-arguments] [nchar](10) NULL,
	[Msapplication-badge] [nchar](10) NULL,
	[Msapplication-id] [nchar](10) NULL,
	[Msapplication-minversion] [nchar](10) NULL,
	[Msapplication-navbutton-color] [nchar](10) NULL,
	[Msapplication-optout] [nchar](10) NULL,
	[Msapplication-packagefamilyname] [nchar](10) NULL,
	[Msapplication-starturl] [nchar](10) NULL,
	[Msapplication-tilecolor] [nchar](10) NULL,
	[Msapplication-task] [nchar](10) NULL,
	[Msapplication-task-separator] [nchar](10) NULL,
	[Msapplication-tooltip] [nchar](10) NULL,
	[Msapplication-tileimage] [nchar](10) NULL,
	[Msapplication-window] [nchar](10) NULL,
	[MSThemeCompatible] [nchar](10) NULL,
	[MSSmartTagsPreventParsing] [nchar](10) NULL,
	[Revisit-after] [nchar](10) NULL,
	[Robots] [nchar](10) NULL,
	[Viewport] [nchar](10) NULL,
 CONSTRAINT [PK_Web_Base_Exts_Meta] PRIMARY KEY CLUSTERED 
(
	[PkId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Web_Base_Exts_Resx]    Script Date: 2015/6/6 14:56:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Web_Base_Exts_Resx](
	[PkId] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[Type] [int] NULL,
	[NodeId] [int] NULL,
	[InfoId] [int] NULL,
	[Banner] [nvarchar](max) NULL,
	[BannersCount] [int] NULL,
	[Guide] [nvarchar](max) NULL,
	[GuidesCount] [int] NULL,
	[Icon] [nvarchar](max) NULL,
	[IconsCount] [int] NULL,
	[Image] [nvarchar](max) NULL,
	[Images] [nvarchar](max) NULL,
	[ImagesCount] [int] NULL,
	[Media] [nvarchar](max) NULL,
	[MediaCount] [int] NULL,
	[Doc] [nvarchar](max) NULL,
	[DocsCount] [int] NULL,
	[Zip] [nvarchar](max) NULL,
	[ZipCount] [int] NULL,
 CONSTRAINT [PK_Web_Base_Exts_Resx] PRIMARY KEY CLUSTERED 
(
	[PkId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Web_Base_Link_Info]    Script Date: 2015/6/6 14:56:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Web_Base_Link_Info](
	[PkId] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[SortId] [int] NULL,
	[ParentId] [int] NULL,
	[NodeId] [int] NULL,
	[Title] [nvarchar](max) NULL,
	[Content] [nvarchar](max) NULL,
	[Icon] [nvarchar](max) NULL,
	[FlagStatus] [int] NULL,
	[FlagView] [int] NULL,
	[FlagStop] [int] NULL,
	[FlagPass] [int] NULL,
 CONSTRAINT [PK_Web_Base_Link_Info] PRIMARY KEY CLUSTERED 
(
	[PkId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Web_Base_Link_Node]    Script Date: 2015/6/6 14:56:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Web_Base_Link_Node](
	[PkId] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[SortId] [int] NULL,
	[ParentId] [int] NULL,
	[NodeId] [int] NULL,
	[Title] [nvarchar](max) NULL,
	[Content] [nvarchar](max) NULL,
	[Icon] [nvarchar](max) NULL,
	[FlagStatus] [int] NULL,
	[FlagView] [int] NULL,
	[FlagStop] [int] NULL,
	[FlagPass] [int] NULL,
 CONSTRAINT [PK_Web_Base_Link_Node] PRIMARY KEY CLUSTERED 
(
	[PkId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Web_Base_News_Group_Info]    Script Date: 2015/6/6 14:56:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Web_Base_News_Group_Info](
	[PkId] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[SiteId] [int] NULL,
	[ParentId] [int] NULL,
	[NodeId] [int] NULL,
	[SortId] [int] NULL,
	[AccId] [int] NULL,
	[AccType] [int] NULL,
	[Title] [nvarchar](max) NULL,
	[TitleSe] [nvarchar](max) NULL,
	[TitleEn] [nvarchar](max) NULL,
	[TitleShort] [nvarchar](max) NULL,
	[TitleExt] [nvarchar](max) NULL,
	[Content] [nvarchar](max) NULL,
	[ContentExt] [nvarchar](max) NULL,
	[Summary] [nvarchar](max) NULL,
	[CssNames] [nvarchar](max) NULL,
	[CssName] [nvarchar](max) NULL,
	[Folder] [nvarchar](max) NULL,
	[Url] [nvarchar](max) NULL,
	[UrlEnable] [int] NULL,
	[Href] [nvarchar](max) NULL,
	[DateTimeOnline] [datetime] NULL,
	[DateTimeOffline] [datetime] NULL,
	[Tag] [nvarchar](max) NULL,
	[KeyWord] [nvarchar](max) NULL,
	[Key] [int] NULL,
	[Keys] [nvarchar](max) NULL,
	[Value] [int] NULL,
	[Values] [nvarchar](max) NULL,
	[LimitDiscuss] [int] NULL,
	[LimitEmotion] [int] NULL,
	[LimitCopyright] [int] NULL,
	[Click] [int] NULL,
	[ClickView] [int] NULL,
	[FlagView] [int] NULL,
	[FlagPass] [int] NULL,
	[FlagStop] [int] NULL,
	[FlagStatus] [int] NULL,
	[TemplateView] [nvarchar](max) NULL,
 CONSTRAINT [PK_Web_Base_News_Group_Info] PRIMARY KEY CLUSTERED 
(
	[PkId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Web_Base_News_Group_Node]    Script Date: 2015/6/6 14:56:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Web_Base_News_Group_Node](
	[PkId] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[SiteId] [int] NULL,
	[ParentId] [int] NULL,
	[NodeId] [int] NULL,
	[SortId] [int] NULL,
	[AccId] [int] NULL,
	[AccType] [int] NULL,
	[Title] [nvarchar](max) NULL,
	[TitleSe] [nvarchar](max) NULL,
	[TitleEn] [nvarchar](max) NULL,
	[TitleShort] [nvarchar](max) NULL,
	[TitleExt] [nvarchar](max) NULL,
	[Content] [nvarchar](max) NULL,
	[ContentExt] [nvarchar](max) NULL,
	[Summary] [nvarchar](max) NULL,
	[CssNames] [nvarchar](max) NULL,
	[CssName] [nvarchar](max) NULL,
	[Folder] [nvarchar](max) NULL,
	[Url] [nvarchar](max) NULL,
	[UrlEnable] [int] NULL,
	[Href] [nvarchar](max) NULL,
	[DateTimeOnline] [datetime] NULL,
	[DateTimeOffline] [datetime] NULL,
	[Tag] [nvarchar](max) NULL,
	[KeyWord] [nvarchar](max) NULL,
	[Key] [int] NULL,
	[Keys] [nvarchar](max) NULL,
	[Value] [int] NULL,
	[Values] [nvarchar](max) NULL,
	[LimitDiscuss] [int] NULL,
	[LimitEmotion] [int] NULL,
	[LimitCopyright] [int] NULL,
	[Click] [int] NULL,
	[ClickView] [int] NULL,
	[FlagView] [int] NULL,
	[FlagPass] [int] NULL,
	[FlagStop] [int] NULL,
	[FlagStatus] [int] NULL,
	[Copyrights] [nvarchar](max) NULL,
	[TemplateIndex] [nvarchar](max) NULL,
	[TemplateNode] [nvarchar](max) NULL,
	[TemplateList] [nvarchar](max) NULL,
	[TemplateView] [nvarchar](max) NULL,
 CONSTRAINT [PK_Web_Base_News_Group_Node] PRIMARY KEY CLUSTERED 
(
	[PkId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Web_Base_News_Info]    Script Date: 2015/6/6 14:56:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Web_Base_News_Info](
	[PkId] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[SiteId] [int] NULL,
	[ParentId] [int] NULL,
	[NodeId] [int] NULL,
	[SortId] [int] NULL,
	[AccId] [int] NULL,
	[AccType] [int] NULL,
	[Title] [nvarchar](max) NULL,
	[TitleSe] [nvarchar](max) NULL,
	[TitleEn] [nvarchar](max) NULL,
	[TitleShort] [nvarchar](max) NULL,
	[TitleExt] [nvarchar](max) NULL,
	[Content] [nvarchar](max) NULL,
	[ContentExt] [nvarchar](max) NULL,
	[Summary] [nvarchar](max) NULL,
	[CssNames] [nvarchar](max) NULL,
	[CssName] [nvarchar](max) NULL,
	[Folder] [nvarchar](max) NULL,
	[Url] [nvarchar](max) NULL,
	[UrlEnable] [int] NULL,
	[Href] [nvarchar](max) NULL,
	[DateTimeOnline] [datetime] NULL,
	[DateTimeOffline] [datetime] NULL,
	[DateTimeView] [datetime] NULL,
	[DateTimeCreate] [datetime] NULL,
	[DateTimeUpdate] [datetime] NULL,
	[DateTimePass] [datetime] NULL,
	[Tag] [nvarchar](max) NULL,
	[KeyWord] [nvarchar](max) NULL,
	[Key] [int] NULL,
	[Keys] [nvarchar](max) NULL,
	[Value] [int] NULL,
	[Values] [nvarchar](max) NULL,
	[LimitDiscuss] [int] NULL,
	[LimitEmotion] [int] NULL,
	[LimitCopyright] [int] NULL,
	[Click] [int] NULL,
	[ClickView] [int] NULL,
	[FlagView] [int] NULL,
	[FlagPass] [int] NULL,
	[FlagStop] [int] NULL,
	[FlagStatus] [int] NULL,
	[TemplateView] [nvarchar](max) NULL,
 CONSTRAINT [PK_Web_Base_News_Info] PRIMARY KEY CLUSTERED 
(
	[PkId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Web_Base_News_Info_Ext]    Script Date: 2015/6/6 14:56:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Web_Base_News_Info_Ext](
	[PkId] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[NodeId] [int] NULL,
	[CreateId] [int] NULL,
	[EditorId] [int] NULL,
	[UpdateId] [int] NULL,
	[PassId] [int] NULL,
	[OrgId] [int] NULL,
	[OrgName] [nvarchar](max) NULL,
	[AuthorId] [int] NULL,
	[AuthorName] [nvarchar](max) NULL,
	[SourceTypeId] [int] NULL,
	[SourceTypeName] [nvarchar](max) NULL,
	[SourceId] [int] NULL,
	[SourceName] [nvarchar](max) NULL,
	[SourceTitle] [nvarchar](max) NULL,
	[SourceUrl] [nvarchar](max) NULL,
	[Copyrights] [nvarchar](max) NULL,
	[Memo] [nvarchar](max) NULL,
	[Message] [nvarchar](max) NULL,
	[Remark] [nvarchar](max) NULL,
	[ValueInt1] [int] NULL,
	[ValueInt2] [int] NULL,
	[ValueInt3] [int] NULL,
	[ValueFloat1] [float] NULL,
	[ValueFloat2] [float] NULL,
	[ValueFloat3] [float] NULL,
	[ValueString1] [nvarchar](max) NULL,
	[ValueString2] [nvarchar](max) NULL,
	[ValueString3] [nvarchar](max) NULL,
	[ValueString4] [nvarchar](max) NULL,
	[ValueString5] [nvarchar](max) NULL,
	[ValueString6] [nvarchar](max) NULL,
	[ValueDateTime1] [datetime] NULL,
	[ValueDateTime2] [datetime] NULL,
	[ValueDateTime3] [datetime] NULL,
 CONSTRAINT [PK_Web_Base_News_Info_Ext] PRIMARY KEY CLUSTERED 
(
	[PkId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Web_Base_News_Node]    Script Date: 2015/6/6 14:56:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Web_Base_News_Node](
	[PkId] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[SiteId] [int] NULL,
	[ParentId] [int] NULL,
	[SortId] [int] NULL,
	[NodeId] [int] NULL,
	[NodeType] [int] NULL,
	[AccId] [int] NULL,
	[AccType] [int] NULL,
	[Title] [nvarchar](max) NULL,
	[TitleSe] [nvarchar](max) NULL,
	[TitleEn] [nvarchar](max) NULL,
	[TitleShort] [nvarchar](max) NULL,
	[TitleExt] [nvarchar](max) NULL,
	[Content] [nvarchar](max) NULL,
	[ContentExt] [nvarchar](max) NULL,
	[Summary] [nvarchar](max) NULL,
	[CssNames] [nvarchar](max) NULL,
	[CssName] [nvarchar](max) NULL,
	[Folder] [nvarchar](max) NULL,
	[Url] [nvarchar](max) NULL,
	[UrlEnable] [int] NULL,
	[Href] [nvarchar](max) NULL,
	[DateTimeOnline] [datetime] NULL,
	[DateTimeOffline] [datetime] NULL,
	[DateTimeView] [datetime] NULL,
	[DateTimeCreate] [datetime] NULL,
	[DateTimeUpdate] [datetime] NULL,
	[DateTimePass] [datetime] NULL,
	[Tag] [nvarchar](max) NULL,
	[KeyWord] [nvarchar](max) NULL,
	[Key] [int] NULL,
	[Keys] [nvarchar](max) NULL,
	[Value] [int] NULL,
	[Values] [nvarchar](max) NULL,
	[LimitDiscuss] [int] NULL,
	[LimitEmotion] [int] NULL,
	[LimitCopyright] [int] NULL,
	[Click] [int] NULL,
	[ClickView] [int] NULL,
	[FlagView] [int] NULL,
	[FlagPass] [int] NULL,
	[FlagStop] [int] NULL,
	[FlagStatus] [int] NULL,
	[Copyrights] [nvarchar](max) NULL,
	[TemplateIndex] [nvarchar](max) NULL,
	[TemplateNode] [nvarchar](max) NULL,
	[TemplateList] [nvarchar](max) NULL,
	[TemplateView] [nvarchar](max) NULL,
 CONSTRAINT [PK_Web_Base_News_Node] PRIMARY KEY CLUSTERED 
(
	[PkId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Web_Base_News_Node_Ext]    Script Date: 2015/6/6 14:56:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Web_Base_News_Node_Ext](
	[PkId] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[NodeId] [int] NULL,
	[CreateId] [int] NULL,
	[EditorId] [int] NULL,
	[UpdateId] [int] NULL,
	[PassId] [int] NULL,
	[Memo] [nvarchar](max) NULL,
	[Message] [nvarchar](max) NULL,
	[Remark] [nvarchar](max) NULL,
	[KeyInt1] [nvarchar](max) NULL,
	[KeyInt2] [nvarchar](max) NULL,
	[KeyInt3] [nvarchar](max) NULL,
	[KeyFloat1] [nvarchar](max) NULL,
	[KeyFloat2] [nvarchar](max) NULL,
	[KeyFloat3] [nvarchar](max) NULL,
	[KeyString1] [nvarchar](max) NULL,
	[KeyString2] [nvarchar](max) NULL,
	[KeyString3] [nvarchar](max) NULL,
	[KeyString4] [nvarchar](max) NULL,
	[KeyString5] [nvarchar](max) NULL,
	[KeyString6] [nvarchar](max) NULL,
	[KeyDateTime1] [nvarchar](max) NULL,
	[KeyDateTime2] [nvarchar](max) NULL,
	[KeyDateTime3] [nvarchar](max) NULL,
 CONSTRAINT [PK_Web_Base_News_Node_Ext] PRIMARY KEY CLUSTERED 
(
	[PkId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
